create procedure [dbo].[BAEOrderCategoryDelete] @OrderCategoryID as
int
AS
    Declare @count AS int;
    SET @count = 1;
    
    if(@OrderCategoryID <> 1)
    BEGIN
        DELETE FROM OrderCategory WHERE OrderCategoryID = @OrderCategoryID;
        
        while(@count > 0)
            BEGIN
                DELETE FROM OrderCategory WHERE OrderCategoryID in (SELECT OrderCategoryID FROM OrderCategoryParentLookup WHERE OrderCategoryParentID NOT IN (SELECT OrderCategoryID FROM OrderCategory))
                SELECT @count = @@rowcount;
            END
    END

GO